﻿CREATE TABLE [dbo].[RoomsFacilities] (
    [RoomId]     INT NOT NULL,
    [FacilityId] INT NOT NULL,
    CONSTRAINT [PK_RoomsFacilities] PRIMARY KEY CLUSTERED ([RoomId] ASC, [FacilityId] ASC),
    CONSTRAINT [FK_RoomsFacilities_Facility] FOREIGN KEY ([FacilityId]) REFERENCES [dbo].[Facilities] ([FacilityId]),
    CONSTRAINT [FK_RoomsFacilities_Room] FOREIGN KEY ([RoomId]) REFERENCES [dbo].[Room] ([RoomId])
);

